<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.Statement"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.ResultSet"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="shortcut icon" href="/images/favicon.ico" />
<title>WESC-无机盐溶解度数据库</title>
</head>
<body style="background-color:white;margin-left:10%; margin-right:10%; background-image:url(/images/bg.jpg)">
<a href=http://zc00106.u03.netjsp.com/><img src="/images/logo1.png"></img></a><h1 align="center">WESC-无机盐溶解度数据库</h1>
<p>WESC无机盐溶解度数据库收录了超过300种常见无机盐化合物在水中不同温度下的溶解度数据。这些数据均来源于<a href="manual/Aqueous_Solubility_of_Inorganic_Compounds_at_Various_Tempera.pdf">《AQUEOUS SOLUBILITY OF INORGANIC COMPOUNDS AT VARIOUS TEMPERATURES》</a>，作者未知，非常感谢该文献的作者对这些溶解度数据进行了编总。为了方便更多的研究人员查询这些数据，我们对该文献中收录的溶解度数据进行了数据库存储，您可以通过输入需要查询的无机盐的化学式进行检索。</p>
<p>在此我们继续沿用文献作者的表示方法，用一定温度下固液平衡时液相的浓度表示化合物的溶解度。数据中所指的固相为通常状况下最为稳定的晶相。在0-100摄氏度之间有些盐的溶解度曲线是不连续的，在这之间，溶解度数据会从某一水合物相到另一水合物相，或是从某一水合物相到无水相。</p>
所有物质的溶解度均用溶质的质量分数表示，100*w2，其中
   <br>w2=m2/(m1+m2)
   <br>m2为溶质的质量，m1为溶剂水的质量。质量分数与其它浓度之间存在以下的换算关系
   <br>体积摩尔浓度：溶质的物质的量与溶液体积之比，c2=1000pw2/M2
   <br>质量摩尔浓度：溶质的物质的量与溶剂水的质量之比，m2=1000w2/M2(1-w2)
   <br>摩尔分数：溶质的物质的量与所有组分的物质的总物质的量之比，x2=(w2/M2){w2/M2+(1-w2)/M1}
   <br>100g水中溶质的质量：r2=100w2/(1-w2)
<p>在此，M2表示溶质的摩尔量，M1为水分子的摩尔量M1=18.015g/mol。p表示溶液的密度，单位为g/cm-3。这些数据是根据以下的参考文献中的数据编总的，在某些情况下这些数据可能已经被重新拟合或内插，那些数据可以从IUPAC溶解度数据系列或者Journal of Physical and Chemical Reference Data中的相关文献中找到。</p>
参考文献：
<br>[1] Solubility Data Series, International Union of Pure and Applied Chemistry. Volumes 1 to 53 were published by Pergamon Press, Oxford, from 1979 to 1994; subsequent volumes were published by Oxford University Press, Oxford. The number following the colon is the volume number in the series.
<br>[2] Clever, H.L., and Johnston, F.J., J. Phys. Chem. Ref. Data, 9, 751, 1980.
<br>[3] Marcus, Y., J. Phys. Chem. Ref. Data, 9, 1307, 1980.
<br>[4] Clever, H.L., Johnson, S.A., and Derrick, M.E., J. Phys. Chem. Ref. Data, 14, 631, 1985.
<br>[5] Clever, H.L., Johnson, S.A., and Derrick, M.E., J. Phys. Chem. Ref. Data, 21, 941, 1992.
<br>[6] Söhnel, O., and Novotny, P., Densities of Aqueous Solutions of Inorganic Substances, Elsevier, Amsterdam, 1985.
<br>[7] Krumgalz, B.S., Mineral Solubility in Water at Various Temperatures, Israel Oceanographic and Limnological Research Ltd., Haifa, 1994.
<br>[8] Potter, R.W., and Clynne, M.A., J. Research U.S. Geological Survey, 6, 701, 1978; Clynne, M.A., and Potter, R.W., J. Chem. Eng. Data, 24, 338, 1979.
<br>[9] Marshal, W.L., and Slusher, R., J. Phys. Chem., 70, 4015, 1966; Knacke, O., and Gans, W., Zeit. Phys. Chem., NF, 104, 41, 1977.
<br>[10] Stephen, H., and Stephen, T., Solubilities of Inorganic and Organic Compounds, Vol. 1, Macmillan, New York, 1963.
<p>网站开发：李东东 <a href=mailto:ddong_li@hotmail.com>ddong_li@hotmail.com</a></p>
<p>数据录入：李东东 <a href=mailto:ddong_li@hotmail.com>ddong_li@hotmail.com</a>；肖树阳 <a href=xiaoshuyang87@163.com>xiaoshuyang87@163.com</a>；</p>
<p><font color=blue>溶解度数据检索，化学式例如NaCl,nacl,AgNO3,agno3,Mg(NO3)2,mg(no3)2等(字母不区分大小写)，NULL表示没有该数据。</font></p>
<form action="index.jsp"><label>化学式：</label><input type="text" name="formula"></input><input type="submit" value="检索"></input></form>
    <%
      String formula = request.getParameter("formula");
      if(formula != null && !formula.matches("")){
    	try{
    		formula = formula.replace("'","");
        	Class.forName("com.mysql.jdbc.Driver");
          	Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/zc00106?useUnicode=true&characterEncoding=utf8", "zc00106", "FfUUOAMb");
          	Statement stmt = conn.createStatement();
      		String sql = "select * from wesc_solubility where compound='" + formula + "'";
      		ResultSet rs = stmt.executeQuery(sql);
      		if(rs.next()){
      			out.println("<table border=1>");
      		  	out.println("<thead><tr bgcolor=#D5D5D5>");
      		  	out.println("<th>化学式</th>");
      		  	out.println("<th>0°C</th>");
      		  	out.println("<th>10°C</th>");
      		  	out.println("<th>20°C</th>");
      		  	out.println("<th>25°C</th>");
      		  	out.println("<th>30°C</th>");
      		  	out.println("<th>40°C</th>");
      		  	out.println("<th>50°C</th>");
      		  	out.println("<th>60°C</th>");
      		  	out.println("<th>70°C</th>");
      		  	out.println("<th>80°C</th>");
      		  	out.println("<th>90°C</th>");
      		  	out.println("<th>100°C</th>");
      		  	out.println("<th>参考文献</th>");
      		  	out.println("</tr></thead>");
      		  	out.println("<tbody><tr>");
      			out.println("<td>" + rs.getString("compound") + "</td>");
      			out.println("<td>" + rs.getString("T_0") + "</td>");
      			out.println("<td>" + rs.getString("T_10") + "</td>");
      			out.println("<td>" + rs.getString("T_20") + "</td>");
      			out.println("<td>" + rs.getString("T_25") + "</td>");
      			out.println("<td>" + rs.getString("T_30") + "</td>");
      			out.println("<td>" + rs.getString("T_40") + "</td>");
      			out.println("<td>" + rs.getString("T_50") + "</td>");
      			out.println("<td>" + rs.getString("T_60") + "</td>");
      			out.println("<td>" + rs.getString("T_70") + "</td>");
      			out.println("<td>" + rs.getString("T_80") + "</td>");
      			out.println("<td>" + rs.getString("T_90") + "</td>");
      			out.println("<td>" + rs.getString("T_100") + "</td>");
      			out.println("<td>" + rs.getString("ref") + "</td>");
      			out.println("</tr></tbody>");
      			out.println("</table>");
      			rs.close();
      			stmt.close();
      			conn.close();
      		}
      		else{
      			out.println("<td><font color=red>对不起,无数据记录</font></td>");
      		}
      	}
        catch(Exception e){
        	out.println("<td>" + e.getMessage() + "</td>");
        }
      }
    %>
  <p align=center>
  	<font size="2px">Copyright &#169; Qinghai Institute of Salt Lakes, CAS. 2011-2012 All Rights Reserved.</font>
    <!-- JiaThis Button BEGIN --><script type="text/javascript" src="http://v1.jiathis.com/code/jiathis_r.js?move=0" charset="utf-8"></script>  <!-- JiaThis Button END --><script src="http://s22.cnzz.com/stat.php?id=3135708&web_id=3135708&show=pic" language="JavaScript"></script>
  </p>
 </body>